CustomerLayawayAccount

Entity Definition

Logical Name : CustomerLayawayAccount
Physical Name : LE_ACNT_CT_LY

A type of CUSTOMER ACCOUNT established to record layaway payments made against merchandise set aside for a customer. The merchandise is retained at the store until the transaction is settled.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
LayawayFeeAmount A one time fee charged to administer a layaway account. MO_LY_FE_AMT Money decimal(16,5)
LayawayMinimumPaymentAmount A minimum monetary amount required to make a payment against the reserved merchandise. MO_LY_MNM_PYM_AMT Money decimal(16,5)
LayawayMinimumPurchaseAmount The minimum monetary value of a purchase required to set up a layaway account. For example a retailer may set up layaways only for purchases that exceed $20.00. MO_LY_MNM_PCH_AMT Money decimal(16,5)
MinimumInitialPaymentAmount The minimum monetary value required as a first payment to set up a layaway account. MO_MNM_INT_PYM_AMT Money decimal(16,5)
MinimumInitialPaymentPercent The minimum percentage of a purchase required as a first payment to set up a layaway account. PE_MNM_INT_PYM Percent decimal(7,4)
RefundAllowedFlag A boolean indicator that if YES means that a customer may cancel a layaway account (in effect a kind of return from layaway reserve inventory) and receive a refund possibley reduced by a cancellation fee. FL_RFD_ALW Flag integer
LayawayCancellationFeeAmount A flat fee charged by a retailer to cancel a layaway. The fee may be deducted from the money refunded to the customer. In a layaway the money refunded is the balance paid into the account by the customer. MO_LY_CNCLLTN_FE_AMT Money decimal(16,5)
LayawayDefaultCancellationDate The date this layaway account will be cancelled if it is not settled. This is a stop loss date. When a layaway purchase is not completed by this date, the account is cancelled, the merchandise is returned to inventory and a refund to the customer is issued (if possible) minus a layaway cancellation fee. For situations where a refund to the customer cannot be made, the account balance is transferred to a liability account where it is carried until it can be taken as income under the local escheatment laws. DC_LY_DFLT_CNCLLTN_DT DateCalendar date

Relationships

Parent Entity Verb Phrase Child Entity
CustomerAccount can be a CustomerLayawayAccount

Logical Views containing CustomerLayawayAccount

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07200 - Customer Purchase Transaction History View